Dataset statistics
| Number of variables | 17 |
|---|---|
| Number of observations | 178396 |
| Missing cells | 0 |
| Missing cells (%) | 0.0% |
| Duplicate rows | 5550 |
| Duplicate rows (%) | 3.1% |
| Total size in memory | 23.3 MiB |
| Average record size in memory | 137.0 B |
Variable types
| Categorical | 4 |
|---|---|
| Numeric | 12 |
| Boolean | 1 |
| Dataset has 5550 (3.1%) duplicate rows | Duplicates |
weather_main is highly imbalanced (51.4%) | Imbalance |
weather_description is highly imbalanced (52.6%) | Imbalance |
pressure is highly skewed (γ1 = 159.8659178) | Skewed |
rain_3h is highly skewed (γ1 = 184.1125344) | Skewed |
snow_3h is highly skewed (γ1 = 68.8350361) | Skewed |
wind_speed has 18490 (10.4%) zeros | Zeros |
wind_deg has 24920 (14.0%) zeros | Zeros |
rain_1h has 159008 (89.1%) zeros | Zeros |
rain_3h has 176541 (99.0%) zeros | Zeros |
snow_3h has 178129 (99.9%) zeros | Zeros |
clouds_all has 82194 (46.1%) zeros | Zeros |
Reproduction
| Analysis started | 2024-08-22 04:22:07.695283 |
|---|---|
| Analysis finished | 2024-08-22 04:23:00.165250 |
| Duration | 52.47 seconds |
| Software version | ydata-profiling vv4.9.0 |
| Download configuration | config.json |
city_name
Categorical
| Distinct | 5 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.7 MiB |
| Madrid | |
|---|---|
| Bilbao | |
| Seville | |
| Barcelona | |
| Valencia |
Length
| Max length | 10 |
|---|---|
| Median length | 8 |
| Mean length | 7.3887699 |
| Min length | 6 |
Characters and Unicode
| Total characters | 1318127 |
|---|---|
| Distinct characters | 16 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Valencia |
|---|---|
| 2nd row | Valencia |
| 3rd row | Valencia |
| 4th row | Valencia |
| 5th row | Valencia |
Common Values
| Value | Count | Frequency (%) |
| Madrid | 36267 | |
| Bilbao | 35951 | |
| Seville | 35557 | |
| Barcelona | 35476 | |
| Valencia | 35145 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| madrid | 36267 | |
| bilbao | 35951 | |
| seville | 35557 | |
| barcelona | 35476 | |
| valencia | 35145 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 213460 | |
| l | 177686 | |
| i | 142920 | |
| e | 141735 | |
| d | 72534 | 5.5% |
| r | 71743 | 5.4% |
| B | 71427 | 5.4% |
| o | 71427 | 5.4% |
| c | 70621 | 5.4% |
| n | 70621 | 5.4% |
| Other values (6) | 213953 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1318127 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| a | 213460 | |
| l | 177686 | |
| i | 142920 | |
| e | 141735 | |
| d | 72534 | 5.5% |
| r | 71743 | 5.4% |
| B | 71427 | 5.4% |
| o | 71427 | 5.4% |
| c | 70621 | 5.4% |
| n | 70621 | 5.4% |
| Other values (6) | 213953 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1318127 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| a | 213460 | |
| l | 177686 | |
| i | 142920 | |
| e | 141735 | |
| d | 72534 | 5.5% |
| r | 71743 | 5.4% |
| B | 71427 | 5.4% |
| o | 71427 | 5.4% |
| c | 70621 | 5.4% |
| n | 70621 | 5.4% |
| Other values (6) | 213953 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1318127 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| a | 213460 | |
| l | 177686 | |
| i | 142920 | |
| e | 141735 | |
| d | 72534 | 5.5% |
| r | 71743 | 5.4% |
| B | 71427 | 5.4% |
| o | 71427 | 5.4% |
| c | 70621 | 5.4% |
| n | 70621 | 5.4% |
| Other values (6) | 213953 |
temp
Real number (ℝ)
| Distinct | 20743 |
|---|---|
| Distinct (%) | 11.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 289.61861 |
| Minimum | 262.24 |
|---|---|
| Maximum | 315.6 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.7 MiB |
Quantile statistics
| Minimum | 262.24 |
|---|---|
| 5-th percentile | 277.25491 |
| Q1 | 283.67 |
| median | 289.15 |
| Q3 | 295.15 |
| 95-th percentile | 303.53 |
| Maximum | 315.6 |
| Range | 53.36 |
| Interquartile range (IQR) | 11.48 |
Descriptive statistics
| Standard deviation | 8.0261993 |
|---|---|
| Coefficient of variation (CV) | 0.027712996 |
| Kurtosis | -0.37694406 |
| Mean | 289.61861 |
| Median Absolute Deviation (MAD) | 5.77 |
| Skewness | 0.22500413 |
| Sum | 51666801 |
| Variance | 64.419875 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 286.15 | 2105 | 1.2% |
| 287.15 | 2061 | 1.2% |
| 289.15 | 2041 | 1.1% |
| 288.15 | 1981 | 1.1% |
| 285.15 | 1870 | 1.0% |
| 290.15 | 1808 | 1.0% |
| 284.15 | 1730 | 1.0% |
| 291.15 | 1643 | 0.9% |
| 283.15 | 1642 | 0.9% |
| 292.15 | 1639 | 0.9% |
| Other values (20733) | 159876 |
| Value | Count | Frequency (%) |
| 262.24 | 1 | < 0.1% |
| 264.132 | 1 | < 0.1% |
| 264.428 | 2 | |
| 265.091 | 2 | |
| 265.261 | 3 | |
| 265.442 | 3 | |
| 265.6245 | 1 | < 0.1% |
| 265.638 | 1 | < 0.1% |
| 265.902 | 3 | |
| 266.0235 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 315.6 | 1 | < 0.1% |
| 315.54 | 1 | < 0.1% |
| 315.15 | 4 | |
| 315.03 | 1 | < 0.1% |
| 314.76 | 6 | |
| 314.7 | 1 | < 0.1% |
| 314.63 | 1 | < 0.1% |
| 314.54 | 3 | |
| 314.51 | 1 | < 0.1% |
| 314.33 | 2 | < 0.1% |
temp_min
Real number (ℝ)
| Distinct | 18553 |
|---|---|
| Distinct (%) | 10.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 288.33044 |
| Minimum | 262.24 |
|---|---|
| Maximum | 315.15 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.7 MiB |
Quantile statistics
| Minimum | 262.24 |
|---|---|
| 5-th percentile | 276.15 |
| Q1 | 282.4836 |
| median | 288.15 |
| Q3 | 293.73013 |
| 95-th percentile | 302.15 |
| Maximum | 315.15 |
| Range | 52.91 |
| Interquartile range (IQR) | 11.246523 |
Descriptive statistics
| Standard deviation | 7.9554909 |
|---|---|
| Coefficient of variation (CV) | 0.027591575 |
| Kurtosis | -0.32857452 |
| Mean | 288.33044 |
| Median Absolute Deviation (MAD) | 5.633 |
| Skewness | 0.21063421 |
| Sum | 51436997 |
| Variance | 63.289836 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 288.15 | 6028 | 3.4% |
| 286.15 | 5706 | 3.2% |
| 287.15 | 5628 | 3.2% |
| 289.15 | 5582 | 3.1% |
| 285.15 | 5417 | 3.0% |
| 283.15 | 5304 | 3.0% |
| 284.15 | 5238 | 2.9% |
| 290.15 | 4963 | 2.8% |
| 281.15 | 4923 | 2.8% |
| 282.15 | 4816 | 2.7% |
| Other values (18543) | 124791 |
| Value | Count | Frequency (%) |
| 262.24 | 1 | < 0.1% |
| 264.132 | 1 | < 0.1% |
| 264.15 | 4 | |
| 264.428 | 2 | < 0.1% |
| 265.091 | 2 | < 0.1% |
| 265.15 | 7 | |
| 265.261 | 3 | |
| 265.442 | 3 | |
| 265.6245 | 1 | < 0.1% |
| 265.638 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 315.15 | 6 | < 0.1% |
| 314.15 | 19 | < 0.1% |
| 313.15 | 39 | |
| 312.381 | 2 | < 0.1% |
| 312.224 | 1 | < 0.1% |
| 312.1675 | 1 | < 0.1% |
| 312.15 | 50 | |
| 312.111 | 1 | < 0.1% |
| 312.04 | 1 | < 0.1% |
| 311.8123438 | 1 | < 0.1% |
temp_max
Real number (ℝ)
| Distinct | 18591 |
|---|---|
| Distinct (%) | 10.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 291.09127 |
| Minimum | 262.24 |
|---|---|
| Maximum | 321.15 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.7 MiB |
Quantile statistics
| Minimum | 262.24 |
|---|---|
| 5-th percentile | 278.15 |
| Q1 | 284.65 |
| median | 290.15 |
| Q3 | 297.15 |
| 95-th percentile | 306.15 |
| Maximum | 321.15 |
| Range | 58.91 |
| Interquartile range (IQR) | 12.5 |
Descriptive statistics
| Standard deviation | 8.612454 |
|---|---|
| Coefficient of variation (CV) | 0.029586783 |
| Kurtosis | -0.32564377 |
| Mean | 291.09127 |
| Median Absolute Deviation (MAD) | 6 |
| Skewness | 0.30169026 |
| Sum | 51929518 |
| Variance | 74.174364 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 288.15 | 5574 | 3.1% |
| 289.15 | 5501 | 3.1% |
| 287.15 | 5354 | 3.0% |
| 286.15 | 5338 | 3.0% |
| 290.15 | 5324 | 3.0% |
| 285.15 | 5211 | 2.9% |
| 284.15 | 5084 | 2.8% |
| 291.15 | 5075 | 2.8% |
| 293.15 | 5051 | 2.8% |
| 292.15 | 4919 | 2.8% |
| Other values (18581) | 125965 |
| Value | Count | Frequency (%) |
| 262.24 | 1 | < 0.1% |
| 264.132 | 1 | < 0.1% |
| 264.428 | 2 | |
| 265.091 | 2 | |
| 265.261 | 3 | |
| 265.442 | 3 | |
| 265.6245 | 1 | < 0.1% |
| 265.638 | 1 | < 0.1% |
| 265.902 | 3 | |
| 266.0235 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 321.15 | 3 | < 0.1% |
| 320.15 | 12 | < 0.1% |
| 319.15 | 34 | < 0.1% |
| 318.71 | 1 | < 0.1% |
| 318.15 | 73 | |
| 317.59 | 2 | < 0.1% |
| 317.15 | 96 | |
| 317.04 | 1 | < 0.1% |
| 316.48 | 7 | < 0.1% |
| 316.15 | 145 |
pressure
Real number (ℝ)
SKEWED
| Distinct | 190 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1069.2607 |
| Minimum | 0 |
|---|---|
| Maximum | 1008371 |
| Zeros | 2 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.7 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 998 |
| Q1 | 1013 |
| median | 1018 |
| Q3 | 1022 |
| 95-th percentile | 1030 |
| Maximum | 1008371 |
| Range | 1008371 |
| Interquartile range (IQR) | 9 |
Descriptive statistics
| Standard deviation | 5969.6319 |
|---|---|
| Coefficient of variation (CV) | 5.5829525 |
| Kurtosis | 26697.242 |
| Mean | 1069.2607 |
| Median Absolute Deviation (MAD) | 4 |
| Skewness | 159.86592 |
| Sum | 1.9075184 × 108 |
| Variance | 35636505 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 1017 | 11414 | 6.4% |
| 1016 | 11357 | 6.4% |
| 1018 | 11321 | 6.3% |
| 1019 | 10500 | 5.9% |
| 1015 | 10468 | 5.9% |
| 1020 | 9371 | 5.3% |
| 1014 | 9129 | 5.1% |
| 1021 | 8623 | 4.8% |
| 1013 | 7687 | 4.3% |
| 1022 | 7409 | 4.2% |
| Other values (180) | 81117 |
| Value | Count | Frequency (%) |
| 0 | 2 | < 0.1% |
| 594 | 1 | < 0.1% |
| 918 | 1 | < 0.1% |
| 923 | 1 | < 0.1% |
| 927 | 1 | < 0.1% |
| 928 | 13 | |
| 929 | 4 | < 0.1% |
| 930 | 6 | |
| 931 | 8 | |
| 932 | 7 |
| Value | Count | Frequency (%) |
| 1008371 | 1 | |
| 1002881 | 1 | |
| 1002241 | 1 | |
| 1001781 | 1 | |
| 1001501 | 1 | |
| 1000951 | 1 | |
| 102153 | 1 | |
| 102132 | 1 | |
| 102075 | 1 | |
| 101983 | 1 |
humidity
Real number (ℝ)
| Distinct | 100 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 68.423457 |
| Minimum | 0 |
|---|---|
| Maximum | 100 |
| Zeros | 63 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.7 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 28 |
| Q1 | 53 |
| median | 72 |
| Q3 | 87 |
| 95-th percentile | 100 |
| Maximum | 100 |
| Range | 100 |
| Interquartile range (IQR) | 34 |
Descriptive statistics
| Standard deviation | 21.902888 |
|---|---|
| Coefficient of variation (CV) | 0.32010788 |
| Kurtosis | -0.61729798 |
| Mean | 68.423457 |
| Median Absolute Deviation (MAD) | 16 |
| Skewness | -0.52543765 |
| Sum | 12206471 |
| Variance | 479.73648 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 93 | 15920 | 8.9% |
| 100 | 10128 | 5.7% |
| 87 | 9781 | 5.5% |
| 82 | 5869 | 3.3% |
| 81 | 4994 | 2.8% |
| 88 | 4731 | 2.7% |
| 77 | 4364 | 2.4% |
| 76 | 4135 | 2.3% |
| 72 | 3439 | 1.9% |
| 78 | 3234 | 1.8% |
| Other values (90) | 111801 |
| Value | Count | Frequency (%) |
| 0 | 63 | |
| 2 | 2 | < 0.1% |
| 3 | 3 | < 0.1% |
| 4 | 2 | < 0.1% |
| 5 | 1 | < 0.1% |
| 6 | 4 | < 0.1% |
| 7 | 10 | < 0.1% |
| 8 | 22 | < 0.1% |
| 9 | 48 | |
| 10 | 60 |
| Value | Count | Frequency (%) |
| 100 | 10128 | |
| 99 | 413 | 0.2% |
| 98 | 547 | 0.3% |
| 97 | 696 | 0.4% |
| 96 | 1010 | 0.6% |
| 95 | 831 | 0.5% |
| 94 | 1669 | 0.9% |
| 93 | 15920 | |
| 92 | 915 | 0.5% |
| 91 | 752 | 0.4% |
wind_speed
Real number (ℝ)
ZEROS
| Distinct | 36 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.4705599 |
| Minimum | 0 |
|---|---|
| Maximum | 133 |
| Zeros | 18490 |
| Zeros (%) | 10.4% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.7 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 1 |
| median | 2 |
| Q3 | 4 |
| 95-th percentile | 6 |
| Maximum | 133 |
| Range | 133 |
| Interquartile range (IQR) | 3 |
Descriptive statistics
| Standard deviation | 2.0959099 |
|---|---|
| Coefficient of variation (CV) | 0.84835422 |
| Kurtosis | 97.124156 |
| Mean | 2.4705599 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 3.1704034 |
| Sum | 440738 |
| Variance | 4.3928383 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=36)
| Value | Count | Frequency (%) |
| 1 | 55201 | |
| 2 | 34548 | |
| 3 | 25036 | |
| 0 | 18490 | 10.4% |
| 4 | 18313 | 10.3% |
| 5 | 11683 | 6.5% |
| 6 | 6794 | 3.8% |
| 7 | 3779 | 2.1% |
| 8 | 2127 | 1.2% |
| 9 | 1154 | 0.6% |
| Other values (26) | 1271 | 0.7% |
| Value | Count | Frequency (%) |
| 0 | 18490 | 10.4% |
| 1 | 55201 | |
| 2 | 34548 | |
| 3 | 25036 | |
| 4 | 18313 | 10.3% |
| 5 | 11683 | 6.5% |
| 6 | 6794 | 3.8% |
| 7 | 3779 | 2.1% |
| 8 | 2127 | 1.2% |
| 9 | 1154 | 0.6% |
| Value | Count | Frequency (%) |
| 133 | 1 | < 0.1% |
| 64 | 1 | < 0.1% |
| 54 | 1 | < 0.1% |
| 43 | 1 | < 0.1% |
| 40 | 1 | < 0.1% |
| 38 | 1 | < 0.1% |
| 35 | 1 | < 0.1% |
| 33 | 1 | < 0.1% |
| 30 | 3 | |
| 29 | 1 | < 0.1% |
wind_deg
Real number (ℝ)
ZEROS
| Distinct | 361 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 166.59119 |
| Minimum | 0 |
|---|---|
| Maximum | 360 |
| Zeros | 24920 |
| Zeros (%) | 14.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.7 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 55 |
| median | 177 |
| Q3 | 270 |
| 95-th percentile | 340 |
| Maximum | 360 |
| Range | 360 |
| Interquartile range (IQR) | 215 |
Descriptive statistics
| Standard deviation | 116.61193 |
|---|---|
| Coefficient of variation (CV) | 0.69998855 |
| Kurtosis | -1.3660842 |
| Mean | 166.59119 |
| Median Absolute Deviation (MAD) | 107 |
| Skewness | -0.031376115 |
| Sum | 29719202 |
| Variance | 13598.341 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 24920 | 14.0% |
| 220 | 5111 | 2.9% |
| 320 | 4419 | 2.5% |
| 330 | 4314 | 2.4% |
| 230 | 4131 | 2.3% |
| 240 | 3650 | 2.0% |
| 290 | 3616 | 2.0% |
| 280 | 3599 | 2.0% |
| 270 | 3573 | 2.0% |
| 310 | 3573 | 2.0% |
| Other values (351) | 117490 |
| Value | Count | Frequency (%) |
| 0 | 24920 | |
| 1 | 82 | < 0.1% |
| 2 | 94 | 0.1% |
| 3 | 85 | < 0.1% |
| 4 | 138 | 0.1% |
| 5 | 94 | 0.1% |
| 6 | 85 | < 0.1% |
| 7 | 115 | 0.1% |
| 8 | 87 | < 0.1% |
| 9 | 97 | 0.1% |
| Value | Count | Frequency (%) |
| 360 | 2631 | |
| 359 | 77 | < 0.1% |
| 358 | 80 | < 0.1% |
| 357 | 77 | < 0.1% |
| 356 | 80 | < 0.1% |
| 355 | 103 | 0.1% |
| 354 | 74 | < 0.1% |
| 353 | 117 | 0.1% |
| 352 | 98 | 0.1% |
| 351 | 82 | < 0.1% |
rain_1h
Real number (ℝ)
ZEROS
| Distinct | 7 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.075491827 |
| Minimum | 0 |
|---|---|
| Maximum | 12 |
| Zeros | 159008 |
| Zeros (%) | 89.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.7 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 0.3 |
| Maximum | 12 |
| Range | 12 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.39884735 |
|---|---|
| Coefficient of variation (CV) | 5.2833182 |
| Kurtosis | 399.47518 |
| Mean | 0.075491827 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 15.893249 |
| Sum | 13467.44 |
| Variance | 0.15907921 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=7)
| Value | Count | Frequency (%) |
| 0 | 159008 | |
| 0.3 | 12795 | 7.2% |
| 0.9 | 5196 | 2.9% |
| 3 | 1310 | 0.7% |
| 12 | 85 | < 0.1% |
| 2.29 | 1 | < 0.1% |
| 0.25 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 0 | 159008 | |
| 0.25 | 1 | < 0.1% |
| 0.3 | 12795 | 7.2% |
| 0.9 | 5196 | 2.9% |
| 2.29 | 1 | < 0.1% |
| 3 | 1310 | 0.7% |
| 12 | 85 | < 0.1% |
| Value | Count | Frequency (%) |
| 12 | 85 | < 0.1% |
| 3 | 1310 | 0.7% |
| 2.29 | 1 | < 0.1% |
| 0.9 | 5196 | 2.9% |
| 0.3 | 12795 | 7.2% |
| 0.25 | 1 | < 0.1% |
| 0 | 159008 |
rain_3h
Real number (ℝ)
SKEWED ZEROS
| Distinct | 89 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.00037976468 |
| Minimum | 0 |
|---|---|
| Maximum | 2.315 |
| Zeros | 176541 |
| Zeros (%) | 99.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.7 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 2.315 |
| Range | 2.315 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.0072884454 |
|---|---|
| Coefficient of variation (CV) | 19.192004 |
| Kurtosis | 57067.406 |
| Mean | 0.00037976468 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 184.11253 |
| Sum | 67.7485 |
| Variance | 5.3121437 × 10-5 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 176541 | |
| 0.01 | 214 | 0.1% |
| 0.005 | 187 | 0.1% |
| 0.015 | 128 | 0.1% |
| 0.025 | 74 | < 0.1% |
| 0.012 | 66 | < 0.1% |
| 0.1 | 64 | < 0.1% |
| 0.002 | 54 | < 0.1% |
| 0.09 | 53 | < 0.1% |
| 0.03 | 53 | < 0.1% |
| Other values (79) | 962 | 0.5% |
| Value | Count | Frequency (%) |
| 0 | 176541 | |
| 0.001 | 22 | < 0.1% |
| 0.002 | 54 | < 0.1% |
| 0.0025 | 29 | < 0.1% |
| 0.003 | 7 | < 0.1% |
| 0.004 | 13 | < 0.1% |
| 0.005 | 187 | 0.1% |
| 0.006 | 10 | < 0.1% |
| 0.007 | 41 | < 0.1% |
| 0.0075 | 6 | < 0.1% |
| Value | Count | Frequency (%) |
| 2.315 | 1 | < 0.1% |
| 0.1 | 64 | |
| 0.098 | 2 | < 0.1% |
| 0.097 | 2 | < 0.1% |
| 0.095 | 48 | |
| 0.093 | 43 | |
| 0.09 | 53 | |
| 0.089 | 2 | < 0.1% |
| 0.0875 | 3 | < 0.1% |
| 0.087 | 6 | < 0.1% |
snow_3h
Real number (ℝ)
SKEWED ZEROS
| Distinct | 66 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.0047629151 |
| Minimum | 0 |
|---|---|
| Maximum | 21.5 |
| Zeros | 178129 |
| Zeros (%) | 99.9% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.7 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 21.5 |
| Range | 21.5 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.22260384 |
|---|---|
| Coefficient of variation (CV) | 46.736891 |
| Kurtosis | 5470.8889 |
| Mean | 0.0047629151 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 68.835036 |
| Sum | 849.685 |
| Variance | 0.04955247 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 178129 | |
| 1.5 | 15 | < 0.1% |
| 2.7 | 15 | < 0.1% |
| 0.7 | 12 | < 0.1% |
| 0.2 | 12 | < 0.1% |
| 0.05 | 9 | < 0.1% |
| 0.6 | 9 | < 0.1% |
| 0.1 | 9 | < 0.1% |
| 1.125 | 6 | < 0.1% |
| 2.899 | 6 | < 0.1% |
| Other values (56) | 174 | 0.1% |
| Value | Count | Frequency (%) |
| 0 | 178129 | |
| 0.001 | 2 | < 0.1% |
| 0.01 | 3 | < 0.1% |
| 0.025 | 3 | < 0.1% |
| 0.028 | 3 | < 0.1% |
| 0.05 | 9 | < 0.1% |
| 0.093 | 3 | < 0.1% |
| 0.1 | 9 | < 0.1% |
| 0.125 | 3 | < 0.1% |
| 0.129 | 4 | < 0.1% |
| Value | Count | Frequency (%) |
| 21.5 | 3 | |
| 20.9 | 3 | |
| 19.9 | 3 | |
| 17 | 3 | |
| 15.875 | 3 | |
| 13.2 | 3 | |
| 12.5 | 3 | |
| 8.9 | 3 | |
| 8.5 | 3 | |
| 8.4 | 3 |
clouds_all
Real number (ℝ)
ZEROS
| Distinct | 97 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 25.073292 |
| Minimum | 0 |
|---|---|
| Maximum | 100 |
| Zeros | 82194 |
| Zeros (%) | 46.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.7 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 20 |
| Q3 | 40 |
| 95-th percentile | 88 |
| Maximum | 100 |
| Range | 100 |
| Interquartile range (IQR) | 40 |
Descriptive statistics
| Standard deviation | 30.774129 |
|---|---|
| Coefficient of variation (CV) | 1.2273669 |
| Kurtosis | -0.57904886 |
| Mean | 25.073292 |
| Median Absolute Deviation (MAD) | 20 |
| Skewness | 0.94684437 |
| Sum | 4472975 |
| Variance | 947.04703 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 82194 | |
| 20 | 31002 | 17.4% |
| 75 | 21940 | 12.3% |
| 40 | 13668 | 7.7% |
| 92 | 4380 | 2.5% |
| 90 | 3760 | 2.1% |
| 8 | 2067 | 1.2% |
| 12 | 1589 | 0.9% |
| 88 | 1266 | 0.7% |
| 32 | 1186 | 0.7% |
| Other values (87) | 15344 | 8.6% |
| Value | Count | Frequency (%) |
| 0 | 82194 | |
| 2 | 138 | 0.1% |
| 3 | 7 | < 0.1% |
| 4 | 357 | 0.2% |
| 5 | 133 | 0.1% |
| 6 | 260 | 0.1% |
| 7 | 3 | < 0.1% |
| 8 | 2067 | 1.2% |
| 9 | 18 | < 0.1% |
| 10 | 789 | 0.4% |
| Value | Count | Frequency (%) |
| 100 | 218 | 0.1% |
| 97 | 2 | < 0.1% |
| 96 | 1 | < 0.1% |
| 95 | 2 | < 0.1% |
| 94 | 2 | < 0.1% |
| 93 | 1 | < 0.1% |
| 92 | 4380 | |
| 91 | 27 | < 0.1% |
| 90 | 3760 | |
| 89 | 98 | 0.1% |
weather_id
Real number (ℝ)
| Distinct | 38 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 759.8319 |
| Minimum | 200 |
|---|---|
| Maximum | 804 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.7 MiB |
Quantile statistics
| Minimum | 200 |
|---|---|
| 5-th percentile | 500 |
| Q1 | 800 |
| median | 800 |
| Q3 | 801 |
| 95-th percentile | 803 |
| Maximum | 804 |
| Range | 604 |
| Interquartile range (IQR) | 1 |
Descriptive statistics
| Standard deviation | 108.73322 |
|---|---|
| Coefficient of variation (CV) | 0.14310168 |
| Kurtosis | 7.0304045 |
| Mean | 759.8319 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | -2.7478683 |
| Sum | 1.3555097 × 108 |
| Variance | 11822.914 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=38)
| Value | Count | Frequency (%) |
| 800 | 82685 | |
| 801 | 32101 | 18.0% |
| 803 | 17448 | 9.8% |
| 802 | 15945 | 8.9% |
| 500 | 10905 | 6.1% |
| 701 | 3908 | 2.2% |
| 501 | 3625 | 2.0% |
| 804 | 2561 | 1.4% |
| 741 | 2506 | 1.4% |
| 300 | 1241 | 0.7% |
| Other values (28) | 5471 | 3.1% |
| Value | Count | Frequency (%) |
| 200 | 92 | 0.1% |
| 201 | 127 | 0.1% |
| 202 | 31 | < 0.1% |
| 210 | 2 | < 0.1% |
| 211 | 789 | |
| 300 | 1241 | |
| 301 | 371 | 0.2% |
| 302 | 14 | < 0.1% |
| 310 | 79 | < 0.1% |
| 311 | 19 | < 0.1% |
| Value | Count | Frequency (%) |
| 804 | 2561 | 1.4% |
| 803 | 17448 | 9.8% |
| 802 | 15945 | 8.9% |
| 801 | 32101 | 18.0% |
| 800 | 82685 | |
| 771 | 1 | < 0.1% |
| 761 | 345 | 0.2% |
| 741 | 2506 | 1.4% |
| 731 | 2 | < 0.1% |
| 721 | 435 | 0.2% |
weather_main
Categorical
IMBALANCE
| Distinct | 12 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.7 MiB |
| clear | |
|---|---|
| clouds | |
| rain | |
| mist | 3908 |
| fog | 2506 |
| Other values (7) | 3851 |
Length
| Max length | 12 |
|---|---|
| Median length | 7 |
| Mean length | 5.28828 |
| Min length | 3 |
Characters and Unicode
| Total characters | 943408 |
|---|---|
| Distinct characters | 20 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 1 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | clear |
|---|---|
| 2nd row | clear |
| 3rd row | clear |
| 4th row | clear |
| 5th row | clear |
Common Values
| Value | Count | Frequency (%) |
| clear | 82685 | |
| clouds | 68055 | |
| rain | 17391 | 9.7% |
| mist | 3908 | 2.2% |
| fog | 2506 | 1.4% |
| drizzle | 1724 | 1.0% |
| thunderstorm | 1041 | 0.6% |
| haze | 435 | 0.2% |
| dust | 347 | 0.2% |
| snow | 270 | 0.2% |
| Other values (2) | 34 | < 0.1% |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| clear | 82685 | |
| clouds | 68055 | |
| rain | 17391 | 9.7% |
| mist | 3908 | 2.2% |
| fog | 2506 | 1.4% |
| drizzle | 1724 | 1.0% |
| thunderstorm | 1041 | 0.6% |
| haze | 435 | 0.2% |
| dust | 347 | 0.2% |
| snow | 270 | 0.2% |
| Other values (2) | 34 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| l | 152466 | |
| c | 150740 | |
| r | 103882 | |
| a | 100512 | |
| e | 85918 | |
| s | 73655 | |
| o | 71905 | |
| d | 71167 | |
| u | 69444 | |
| i | 23023 | 2.4% |
| Other values (10) | 40696 | 4.3% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 943408 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| l | 152466 | |
| c | 150740 | |
| r | 103882 | |
| a | 100512 | |
| e | 85918 | |
| s | 73655 | |
| o | 71905 | |
| d | 71167 | |
| u | 69444 | |
| i | 23023 | 2.4% |
| Other values (10) | 40696 | 4.3% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 943408 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| l | 152466 | |
| c | 150740 | |
| r | 103882 | |
| a | 100512 | |
| e | 85918 | |
| s | 73655 | |
| o | 71905 | |
| d | 71167 | |
| u | 69444 | |
| i | 23023 | 2.4% |
| Other values (10) | 40696 | 4.3% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 943408 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| l | 152466 | |
| c | 150740 | |
| r | 103882 | |
| a | 100512 | |
| e | 85918 | |
| s | 73655 | |
| o | 71905 | |
| d | 71167 | |
| u | 69444 | |
| i | 23023 | 2.4% |
| Other values (10) | 40696 | 4.3% |
weather_description
Categorical
IMBALANCE
| Distinct | 43 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.7 MiB |
| sky is clear | |
|---|---|
| few clouds | |
| broken clouds | |
| scattered clouds | |
| light rain | |
| Other values (38) |
Length
| Max length | 28 |
|---|---|
| Median length | 27 |
| Mean length | 11.950442 |
| Min length | 3 |
Characters and Unicode
| Total characters | 2131911 |
|---|---|
| Distinct characters | 26 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 3 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | sky is clear |
|---|---|
| 2nd row | sky is clear |
| 3rd row | sky is clear |
| 4th row | sky is clear |
| 5th row | sky is clear |
Common Values
| Value | Count | Frequency (%) |
| sky is clear | 82685 | |
| few clouds | 32101 | 18.0% |
| broken clouds | 17448 | 9.8% |
| scattered clouds | 15945 | 8.9% |
| light rain | 10905 | 6.1% |
| mist | 3908 | 2.2% |
| moderate rain | 3621 | 2.0% |
| overcast clouds | 2561 | 1.4% |
| fog | 2506 | 1.4% |
| light intensity drizzle | 1241 | 0.7% |
| Other values (33) | 5475 | 3.1% |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| sky | 82685 | |
| clear | 82685 | |
| is | 82685 | |
| clouds | 68055 | |
| few | 32101 | 7.4% |
| rain | 17772 | 4.1% |
| broken | 17448 | 4.0% |
| scattered | 15945 | 3.7% |
| light | 13142 | 3.0% |
| mist | 3908 | 0.9% |
| Other values (21) | 20101 | 4.6% |
Most occurring characters
| Value | Count | Frequency (%) |
| s | 262398 | |
| 258131 | ||
| e | 183492 | 8.6% |
| c | 169246 | 7.9% |
| l | 165627 | 7.8% |
| r | 146533 | 6.9% |
| i | 127835 | 6.0% |
| a | 124428 | 5.8% |
| k | 100166 | 4.7% |
| o | 98132 | 4.6% |
| Other values (16) | 495923 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 2131911 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| s | 262398 | |
| 258131 | ||
| e | 183492 | 8.6% |
| c | 169246 | 7.9% |
| l | 165627 | 7.8% |
| r | 146533 | 6.9% |
| i | 127835 | 6.0% |
| a | 124428 | 5.8% |
| k | 100166 | 4.7% |
| o | 98132 | 4.6% |
| Other values (16) | 495923 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 2131911 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| s | 262398 | |
| 258131 | ||
| e | 183492 | 8.6% |
| c | 169246 | 7.9% |
| l | 165627 | 7.8% |
| r | 146533 | 6.9% |
| i | 127835 | 6.0% |
| a | 124428 | 5.8% |
| k | 100166 | 4.7% |
| o | 98132 | 4.6% |
| Other values (16) | 495923 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 2131911 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| s | 262398 | |
| 258131 | ||
| e | 183492 | 8.6% |
| c | 169246 | 7.9% |
| l | 165627 | 7.8% |
| r | 146533 | 6.9% |
| i | 127835 | 6.0% |
| a | 124428 | 5.8% |
| k | 100166 | 4.7% |
| o | 98132 | 4.6% |
| Other values (16) | 495923 |
weather_icon
Categorical
| Distinct | 24 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.7 MiB |
| 01n | |
|---|---|
| 01d | |
| 02d | |
| 02n | |
| 04d | |
| Other values (19) |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 2.8906197 |
| Min length | 2 |
Characters and Unicode
| Total characters | 515675 |
|---|---|
| Distinct characters | 9 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 01n |
|---|---|
| 2nd row | 01n |
| 3rd row | 01n |
| 4th row | 01n |
| 5th row | 01n |
Common Values
| Value | Count | Frequency (%) |
| 01n | 38541 | |
| 01d | 34830 | |
| 02d | 19199 | |
| 02n | 12368 | 6.9% |
| 04d | 9137 | 5.1% |
| 04n | 8403 | 4.7% |
| 03d | 7870 | 4.4% |
| 10n | 5951 | 3.3% |
| 01 | 5946 | 3.3% |
| 03n | 5833 | 3.3% |
| Other values (14) | 30318 |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| 01n | 38541 | |
| 01d | 34830 | |
| 02d | 19199 | |
| 02n | 12368 | 6.9% |
| 04d | 9137 | 5.1% |
| 04n | 8403 | 4.7% |
| 03d | 7870 | 4.4% |
| 10n | 5951 | 3.3% |
| 01 | 5946 | 3.3% |
| 03n | 5833 | 3.3% |
| Other values (14) | 30318 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 177085 | |
| 1 | 97419 | |
| d | 81590 | |
| n | 77293 | |
| 2 | 35469 | 6.9% |
| 4 | 20009 | 3.9% |
| 3 | 16215 | 3.1% |
| 5 | 7230 | 1.4% |
| 9 | 3365 | 0.7% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 515675 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 177085 | |
| 1 | 97419 | |
| d | 81590 | |
| n | 77293 | |
| 2 | 35469 | 6.9% |
| 4 | 20009 | 3.9% |
| 3 | 16215 | 3.1% |
| 5 | 7230 | 1.4% |
| 9 | 3365 | 0.7% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 515675 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 177085 | |
| 1 | 97419 | |
| d | 81590 | |
| n | 77293 | |
| 2 | 35469 | 6.9% |
| 4 | 20009 | 3.9% |
| 3 | 16215 | 3.1% |
| 5 | 7230 | 1.4% |
| 9 | 3365 | 0.7% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 515675 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 177085 | |
| 1 | 97419 | |
| d | 81590 | |
| n | 77293 | |
| 2 | 35469 | 6.9% |
| 4 | 20009 | 3.9% |
| 3 | 16215 | 3.1% |
| 5 | 7230 | 1.4% |
| 9 | 3365 | 0.7% |
temp_eq
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.5 MiB |
| True | |
|---|---|
| False |
| Value | Count | Frequency (%) |
| True | 109230 | |
| False | 69166 |
A simple visualization of nullity by column.
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.
| city_name | temp | temp_min | temp_max | pressure | humidity | wind_speed | wind_deg | rain_1h | rain_3h | snow_3h | clouds_all | weather_id | weather_main | weather_description | weather_icon | temp_eq | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| dt_iso | |||||||||||||||||
| 2014-12-31 23:00:00+00:00 | Valencia | 270.475 | 270.475 | 270.475 | 1001 | 77 | 1 | 62 | 0.0 | 0.0 | 0.0 | 0 | 800 | clear | sky is clear | 01n | False |
| 2015-01-01 00:00:00+00:00 | Valencia | 270.475 | 270.475 | 270.475 | 1001 | 77 | 1 | 62 | 0.0 | 0.0 | 0.0 | 0 | 800 | clear | sky is clear | 01n | False |
| 2015-01-01 01:00:00+00:00 | Valencia | 269.686 | 269.686 | 269.686 | 1002 | 78 | 0 | 23 | 0.0 | 0.0 | 0.0 | 0 | 800 | clear | sky is clear | 01n | False |
| 2015-01-01 02:00:00+00:00 | Valencia | 269.686 | 269.686 | 269.686 | 1002 | 78 | 0 | 23 | 0.0 | 0.0 | 0.0 | 0 | 800 | clear | sky is clear | 01n | False |
| 2015-01-01 03:00:00+00:00 | Valencia | 269.686 | 269.686 | 269.686 | 1002 | 78 | 0 | 23 | 0.0 | 0.0 | 0.0 | 0 | 800 | clear | sky is clear | 01n | False |
| 2015-01-01 04:00:00+00:00 | Valencia | 270.292 | 270.292 | 270.292 | 1004 | 71 | 2 | 321 | 0.0 | 0.0 | 0.0 | 0 | 800 | clear | sky is clear | 01n | False |
| 2015-01-01 05:00:00+00:00 | Valencia | 270.292 | 270.292 | 270.292 | 1004 | 71 | 2 | 321 | 0.0 | 0.0 | 0.0 | 0 | 800 | clear | sky is clear | 01n | False |
| 2015-01-01 06:00:00+00:00 | Valencia | 270.292 | 270.292 | 270.292 | 1004 | 71 | 2 | 321 | 0.0 | 0.0 | 0.0 | 0 | 800 | clear | sky is clear | 01n | False |
| 2015-01-01 07:00:00+00:00 | Valencia | 274.601 | 274.601 | 274.601 | 1005 | 71 | 1 | 307 | 0.0 | 0.0 | 0.0 | 0 | 800 | clear | sky is clear | 01d | False |
| 2015-01-01 08:00:00+00:00 | Valencia | 274.601 | 274.601 | 274.601 | 1005 | 71 | 1 | 307 | 0.0 | 0.0 | 0.0 | 0 | 800 | clear | sky is clear | 01d | False |
| city_name | temp | temp_min | temp_max | pressure | humidity | wind_speed | wind_deg | rain_1h | rain_3h | snow_3h | clouds_all | weather_id | weather_main | weather_description | weather_icon | temp_eq | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| dt_iso | |||||||||||||||||
| 2018-12-31 13:00:00+00:00 | Seville | 289.15 | 289.15 | 289.15 | 1029 | 59 | 5 | 60 | 0.0 | 0.0 | 0.0 | 0 | 800 | clear | sky is clear | 01d | False |
| 2018-12-31 14:00:00+00:00 | Seville | 290.15 | 290.15 | 290.15 | 1028 | 51 | 5 | 40 | 0.0 | 0.0 | 0.0 | 0 | 800 | clear | sky is clear | 01d | False |
| 2018-12-31 15:00:00+00:00 | Seville | 291.15 | 291.15 | 291.15 | 1028 | 48 | 5 | 50 | 0.0 | 0.0 | 0.0 | 0 | 800 | clear | sky is clear | 01d | False |
| 2018-12-31 16:00:00+00:00 | Seville | 291.15 | 291.15 | 291.15 | 1028 | 42 | 4 | 50 | 0.0 | 0.0 | 0.0 | 0 | 800 | clear | sky is clear | 01d | False |
| 2018-12-31 17:00:00+00:00 | Seville | 291.38 | 290.15 | 292.15 | 1028 | 42 | 4 | 60 | 0.0 | 0.0 | 0.0 | 0 | 800 | clear | sky is clear | 01d | True |
| 2018-12-31 18:00:00+00:00 | Seville | 287.76 | 287.15 | 288.15 | 1028 | 54 | 3 | 30 | 0.0 | 0.0 | 0.0 | 0 | 800 | clear | sky is clear | 01n | True |
| 2018-12-31 19:00:00+00:00 | Seville | 285.76 | 285.15 | 286.15 | 1029 | 62 | 3 | 30 | 0.0 | 0.0 | 0.0 | 0 | 800 | clear | sky is clear | 01n | True |
| 2018-12-31 20:00:00+00:00 | Seville | 285.15 | 285.15 | 285.15 | 1028 | 58 | 4 | 50 | 0.0 | 0.0 | 0.0 | 0 | 800 | clear | sky is clear | 01n | False |
| 2018-12-31 21:00:00+00:00 | Seville | 284.15 | 284.15 | 284.15 | 1029 | 57 | 4 | 60 | 0.0 | 0.0 | 0.0 | 0 | 800 | clear | sky is clear | 01n | False |
| 2018-12-31 22:00:00+00:00 | Seville | 283.97 | 282.15 | 285.15 | 1029 | 70 | 3 | 50 | 0.0 | 0.0 | 0.0 | 0 | 800 | clear | sky is clear | 01n | True |
Most frequently occurring
| city_name | temp | temp_min | temp_max | pressure | humidity | wind_speed | wind_deg | rain_1h | rain_3h | snow_3h | clouds_all | weather_id | weather_main | weather_description | weather_icon | temp_eq | # duplicates | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 948 | Barcelona | 296.338 | 296.338 | 296.338 | 1024 | 100 | 4 | 243 | 0.0 | 0.0 | 0.0 | 0 | 800 | clear | sky is clear | 01d | False | 29 |
| 1586 | Bilbao | 297.988 | 297.988 | 297.988 | 986 | 60 | 1 | 123 | 0.0 | 0.0 | 0.0 | 12 | 801 | clouds | few clouds | 02d | False | 29 |
| 2383 | Madrid | 292.138 | 292.138 | 292.138 | 959 | 94 | 0 | 13 | 0.0 | 0.0 | 0.0 | 0 | 800 | clear | sky is clear | 01d | False | 29 |
| 4949 | Valencia | 290.588 | 290.588 | 290.588 | 992 | 92 | 0 | 21 | 0.0 | 0.0 | 0.0 | 0 | 800 | clear | sky is clear | 01d | False | 29 |
| 3636 | Seville | 295.688 | 295.688 | 295.688 | 1025 | 75 | 2 | 276 | 0.0 | 0.0 | 0.0 | 0 | 800 | clear | sky is clear | 01d | False | 27 |
| 3637 | Seville | 295.688 | 295.688 | 295.688 | 1025 | 75 | 2 | 276 | 0.0 | 0.0 | 0.0 | 0 | 800 | clear | sky is clear | 01n | False | 17 |
| 949 | Barcelona | 296.338 | 296.338 | 296.338 | 1024 | 100 | 4 | 243 | 0.0 | 0.0 | 0.0 | 0 | 800 | clear | sky is clear | 01n | False | 15 |
| 1587 | Bilbao | 297.988 | 297.988 | 297.988 | 986 | 60 | 1 | 123 | 0.0 | 0.0 | 0.0 | 12 | 801 | clouds | few clouds | 02n | False | 15 |
| 2384 | Madrid | 292.138 | 292.138 | 292.138 | 959 | 94 | 0 | 13 | 0.0 | 0.0 | 0.0 | 0 | 800 | clear | sky is clear | 01n | False | 15 |
| 4950 | Valencia | 290.588 | 290.588 | 290.588 | 992 | 92 | 0 | 21 | 0.0 | 0.0 | 0.0 | 0 | 800 | clear | sky is clear | 01n | False | 15 |